adbeaver.AdBeaver INFO Logging to console configured adbeaver.settings INFO Settings.init() adbeaver.settings DEBUG Setting default preferences adbeaver.settings DEBUG set default preference enabled to true adbeaver.settings DEBUG preference enabled changed adbeaver.settings DEBUG set default preference apikey to adbeaver.settings DEBUG preference apikey changed adbeaver.settings DEBUG set default preference addonId to adbeaver.settings DEBUG set default preference liteMode to false adbeaver.settings DEBUG preference liteMode changed adbeaver.settings DEBUG set default preference campaign to adbeaver.settings DEBUG set default preference disableBtn to true adbeaver.settings DEBUG preference disableBtn changed adbeaver.AdBeaver INFO AddonId: 016d2d45-961e-4bac-bb4f-5055f3b543a6 adbeaver.AdBeaver INFO Locale: he adbeaver.AdBeaver INFO AdBeaver.startup() adbeaver.callback INFO CallbackManager.init() adbeaver.AdBeaver INFO >>>>>> START TIMER <<<<<<< adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 0 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 addons.xpi WARN Failed to remove temporary file C:\Users\User\AppData\Local\Temp\tmp-cxd.xpi for addon https://addons.mozilla.org/firefox/downloads/latest/533464/addon-533464-latest.xpi adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 71 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 92 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 113 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 144 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 176 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 207 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 238 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 269 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO StartTimer with: Max: 300 Steps: 20 adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay runs 301 adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver INFO >>>> AdBeaver.startupWithDelay: MaxDelay reached! adbeaver.AdBlockFacade DEBUG Adblocker is not installed adbeaver.AdBeaver DEBUG AdBeaver could not be started, it depends on AdBlock Plus adbeaver.AdBeaver INFO AdBeaver.checkPreconditions adbeaver.AdBeaver INFO checkPreconditions: findOthers: ,,,, adbeaver.AdBeaver DEBUG register windowOpened (CallbackManager) Services.HealthReport.HealthReporter INFO Initializing health reporter instance against datareporting.healthreport. Services.HealthReport.HealthReporter DEBUG Storing state in C:\Users\User\AppData\Roaming\Mozilla\Firefox\Profiles\ppwcp417.default\healthreport\state.json Services.HealthReport.HealthReporter WARN Saved state file does not exist. Services.HealthReport.HealthReporter DEBUG No prefs data found. Sqlite.ConnectionOpener INFO Opening database: C:\Users\User\AppData\Roaming\Mozilla\Firefox\Profiles\ppwcp417.default\healthreport.sqlite (healthreport.sqlite#0) Sqlite.ConnectionOpener INFO Connection opened Sqlite.Connection INFO healthreport.sqlite#0: Opened Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #0 PRAGMA page_size Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #0 finished. Services.Metrics.MetricsStorage DEBUG Page size is 32768 Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #1 PRAGMA temp_store=MEMORY Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #1 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #2 PRAGMA journal_mode=WAL Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #2 finished. Services.Metrics.MetricsStorage INFO Journal mode is wal Services.Metrics.MetricsStorage INFO WAL auto checkpoint pages: 16 Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Services.Metrics.MetricsStorage INFO Setting WAL auto checkpoint to 0 Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #3 PRAGMA wal_autocheckpoint=0 Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #3 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Sqlite.Connection DEBUG healthreport.sqlite#0: Beginning transaction Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #4 BEGIN DEFERRED TRANSACTION Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #4 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #5 PRAGMA user_version Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #5 finished. Services.Metrics.MetricsStorage DEBUG Database schema up to date. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #6 COMMIT TRANSACTION Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #6 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #7 SELECT * FROM types Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #7 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #8 SELECT * FROM v_measurements Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #8 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #9 SELECT * FROM v_fields Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #9 finished. Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Services.Metrics.MetricsStorage INFO Setting WAL auto checkpoint to 16 Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #10 PRAGMA wal_autocheckpoint=16 Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #10 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Services.HealthReport.HealthReporter INFO Storage initialized. Services.HealthReport.HealthReporter INFO Initializing provider manager. Services.Metrics.ProviderManager INFO Registering providers from category: healthreport-js-provider-default Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: AddonsProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.addons Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: AppInfoProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.appInfo Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: CrashesProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.crashes Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: ExperimentsProvider from resource:///modules/experiments/Experiments.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: HealthReportProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: HotfixProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.hotfix Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: PasswordsMetricsProvider from resource://gre/modules/LoginManagerParent.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: PlacesProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: ProfileMetadataProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.profile Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: SearchesProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: SessionsProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.appSessions Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: SyncProvider from resource://services-sync/healthreport.jsm Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: SysInfoProvider from resource://gre/modules/HealthReport.jsm Services.Metrics.ProviderManager INFO Provider is pull-only. Deferring initialization: org.mozilla.sysinfo Services.Metrics.ProviderManager INFO Attempting to load provider from category manager: UITourMetricsProvider from resource:///modules/UITour.jsm Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.addons Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.experiments Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.experiments Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.healthreport Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.healthreport Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.passwordmgr Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.passwordmgr Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.places Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.places Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.searches Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.searches Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.sync Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.sync Services.Metrics.ProviderManager INFO Initializing provider with storage: org.mozilla.uitour Services.Metrics.ProviderManager INFO Provider successfully initialized: org.mozilla.uitour Services.HealthReport.HealthReporter DEBUG Provider manager initialized. Services.HealthReport.HealthReporter INFO HealthReporter started. Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Sqlite.Connection DEBUG healthreport.sqlite#0: Discarded 0 cached statements. Sqlite.Connection INFO healthreport.sqlite#0: Shrinking memory usage. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #11 PRAGMA shrink_memory Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #11 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. adbeaver.AdBeaver INFO AdBeaver.shutdown() adbeaver.AdBeaver DEBUG deactivate adbeaver adbeaver.AdBeaver DEBUG unregister locationChange (CallbackManager) adbeaver.AdBeaver DEBUG unregister domContentLoaded (CallbackManager) addons.xpi WARN Exception running bootstrap method shutdown on adbeaver@adbeaver.org Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #12 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":11,"days":16911,"value":8} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #13 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":8,"days":16911,"value":1} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #14 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":10,"days":16911,"value":10} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #15 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":1,"days":16911,"value":"{\"{81BF1D23-5F17-408D-AC6B-BD6DF7CAF670}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"iMacros for Firefox\",\"version\":\"8.9.6\",\"type\":\"extension\",\"scope\":1,\"description\":\"Automate your web browser. Record and replay repetitious work.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16877,\"updateDay\":16877},\"{1BFCBDFC-41DB-11E1-9FC4-D3C94824019B}\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"Rumola - bypass CAPTCHA\",\"version\":\"3.0.1.1-signed\",\"type\":\"extension\",\"scope\":1,\"description\":\"Solves those tricky authorization text filled images in web pages (CAPTCHAs) instead of you.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16880,\"updateDay\":16880},\"{a6fd85ed-e919-4a43-a5af-8da18bda539f}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"Selenium IDE\",\"version\":\"2.9.1\",\"type\":\"extension\",\"scope\":1,\"description\":\"Record, edit and play Selenium tests\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16882,\"updateDay\":16882},\"client@anonymox.net\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"anonymoX\",\"version\":\"2.5.2\",\"type\":\"extension\",\"scope\":1,\"description\":\"Easy anonymous web browsing and bypassing of web censorship. No proxys or other programs needed. With many functions to protect privacy.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16891,\"updateDay\":16891},\"admin@hide-my-ip.org\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"Hide My IP\",\"version\":\"9.2.0\",\"type\":\"extension\",\"scope\":1,\"description\":\"Hide My IP is number one tool for hiding your IP and unblocking any web site!\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16897,\"updateDay\":16897},\"loop@mozilla.org\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"Firefox Hello Beta\",\"version\":\"1.1.14\",\"type\":\"extension\",\"scope\":1,\"description\":\"Web sharing for Firefox\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16864,\"updateDay\":16911},\"{3e9bb2a7-62ca-4efa-a4e6-f6f6168a652d}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"ShowIP\",\"version\":\"2.7.7.1-signed\",\"type\":\"extension\",\"scope\":1,\"description\":\"Show the IP address of the current page in the status bar. It also allows querying custom services by IP (right mouse button) and Hostname (left mouse button), like whois, netcraft. Additionally you can copy the IP address to the clipboard. This extension was formerly known as ipv6ident. License GPLv2 only.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16911,\"updateDay\":16911},\"adbeaver@adbeaver.org\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"AdBeaver\",\"version\":\"0.7.2.9\",\"type\":\"extension\",\"scope\":1,\"description\":\"Collect what you desurf\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16911,\"updateDay\":16911}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #12 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #13 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #14 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #15 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #16 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":2,"days":16911,"value":"{\"nppdf32.dll:Adobe Acrobat:10.1.7.27:Adobe PDF Plug-In For Firefox and Netscape 10.1.7\":{\"mimeTypes\":[\"application/pdf\",\"application/vnd.adobe.pdfxml\",\"application/vnd.adobe.x-mars\",\"application/vnd.fdf\",\"application/vnd.adobe.xfdf\",\"application/vnd.adobe.xdp+xml\",\"application/vnd.adobe.xfd+xml\"],\"name\":\"Adobe Acrobat\",\"version\":\"10.1.7.27\",\"description\":\"Adobe PDF Plug-In For Firefox and Netscape 10.1.7\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npGoogleUpdate3.dll:Google Update:1.3.29.5:Google Update\":{\"mimeTypes\":[\"application/x-vnd.google.update3webcontrol.3\",\"application/x-vnd.google.oneclickctrl.9\"],\"name\":\"Google Update\",\"version\":\"1.3.29.5\",\"description\":\"Google Update\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPAUTHZ.DLL:Microsoft Office 2010:14.0.4730.1010:Office Authorization plug-in for NPAPI browsers\":{\"mimeTypes\":[\"application/x-msoffice14\"],\"name\":\"Microsoft Office 2010\",\"version\":\"14.0.4730.1010\",\"description\":\"Office Authorization plug-in for NPAPI browsers\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPSPWRAP.DLL:Microsoft Office 2010:14.0.4761.1000:The plug-in allows you to open and edit files using Microsoft Office applications\":{\"mimeTypes\":[\"application/x-sharepoint\"],\"name\":\"Microsoft Office 2010\",\"version\":\"14.0.4761.1000\",\"description\":\"The plug-in allows you to open and edit files using Microsoft Office applications\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npctrl.dll:Silverlight Plug-In:5.1.41212.0:5.1.41212.0\":{\"mimeTypes\":[\"application/x-silverlight\",\"application/x-silverlight-2\"],\"name\":\"Silverlight Plug-In\",\"version\":\"5.1.41212.0\",\"description\":\"5.1.41212.0\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npjp2.dll:Java(TM) Platform SE 7 U45:10.45.2.18:Next Generation Java Plug-in 10.45.2 for Mozilla browsers\":{\"mimeTypes\":[\"application/x-java-applet\",\"application/x-java-bean\",\"application/x-java-vm\",\"application/x-java-applet;version=1.1.1\",\"application/x-java-bean;version=1.1.1\",\"application/x-java-applet;version=1.1\",\"application/x-java-bean;version=1.1\",\"application/x-java-applet;version=1.2\",\"application/x-java-bean;version=1.2\",\"application/x-java-applet;version=1.1.3\",\"application/x-java-bean;version=1.1.3\",\"application/x-java-applet;version=1.1.2\",\"application/x-java-bean;version=1.1.2\",\"application/x-java-applet;version=1.3\",\"application/x-java-bean;version=1.3\",\"application/x-java-applet;version=1.2.2\",\"application/x-java-bean;version=1.2.2\",\"application/x-java-applet;version=1.2.1\",\"application/x-java-bean;version=1.2.1\",\"application/x-java-applet;version=1.3.1\",\"application/x-java-bean;version=1.3.1\",\"application/x-java-applet;version=1.4\",\"application/x-java-bean;version=1.4\",\"application/x-java-applet;version=1.4.1\",\"application/x-java-bean;version=1.4.1\",\"application/x-java-applet;version=1.4.2\",\"application/x-java-bean;version=1.4.2\",\"application/x-java-applet;version=1.5\",\"application/x-java-bean;version=1.5\",\"application/x-java-applet;version=1.6\",\"application/x-java-bean;version=1.6\",\"application/x-java-applet;version=1.7\",\"application/x-java-bean;version=1.7\",\"application/x-java-applet;jpi-version=1.7.0_45\",\"application/x-java-bean;jpi-version=1.7.0_45\",\"application/x-java-vm-npruntime\",\"application/x-java-applet;deploy=10.45.2\",\"application/x-java-applet;javafx=2.2.45\"],\"name\":\"Java(TM) Platform SE 7 U45\",\"version\":\"10.45.2.18\",\"description\":\"Next Generation Java Plug-in 10.45.2 for Mozilla browsers\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npdeployJava1.dll:Java Deployment Toolkit 7.0.450.18:10.45.2.18:NPRuntime Script Plug-in Library for Java(TM) Deploy\":{\"mimeTypes\":[\"application/java-deployment-toolkit\"],\"name\":\"Java Deployment Toolkit 7.0.450.18\",\"version\":\"10.45.2.18\",\"description\":\"NPRuntime Script Plug-in Library for Java(TM) Deploy\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"np32dsw_1207148.dll:Shockwave for Director:12.0.7.148:Adobe Shockwave for Director Netscape plug-in, version 12.0.7.148\":{\"mimeTypes\":[\"application/x-director\"],\"name\":\"Shockwave for Director\",\"version\":\"12.0.7.148\",\"description\":\"Adobe Shockwave for Director Netscape plug-in, version 12.0.7.148\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPSWF32_11_9_900_170.dll:Shockwave Flash:11.9.900.170:Shockwave Flash 11.9 r900\":{\"mimeTypes\":[\"application/x-shockwave-flash\",\"application/futuresplash\"],\"name\":\"Shockwave Flash\",\"version\":\"11.9.900.170\",\"description\":\"Shockwave Flash 11.9 r900\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":false}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #16 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #17 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":3,"days":16911,"value":"{\"gmp-gmpopenh264\":{\"version\":\"1.5.3\",\"userDisabled\":false,\"applyBackgroundUpdates\":1},\"gmp-eme-adobe\":{\"version\":\"15\",\"userDisabled\":false,\"applyBackgroundUpdates\":1}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #17 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Sqlite.Connection TRACE places.sqlite#1: Stmt #3 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"https://www.google.co.il/"} Sqlite.Connection DEBUG places.sqlite#1: Stmt #3 finished. Sqlite.Connection TRACE places.sqlite#1: Stmt #4 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"https://www.google.co.il/"} Sqlite.Connection DEBUG places.sqlite#1: Stmt #4 finished. adbeaver.callback INFO DOMContentLoaded: https://www.google.co.il/ adbeaver.AdBeaver DEBUG show notification Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #18 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":11,"days":16911,"value":7} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #19 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":8,"days":16911,"value":1} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #20 INSERT OR REPLACE INTO daily_last_numeric VALUES (:field_id, :days, :value) - {"field_id":10,"days":16911,"value":10} Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #21 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":1,"days":16911,"value":"{\"{81BF1D23-5F17-408D-AC6B-BD6DF7CAF670}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"iMacros for Firefox\",\"version\":\"8.9.6\",\"type\":\"extension\",\"scope\":1,\"description\":\"Automate your web browser. Record and replay repetitious work.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16877,\"updateDay\":16877},\"{1BFCBDFC-41DB-11E1-9FC4-D3C94824019B}\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"Rumola - bypass CAPTCHA\",\"version\":\"3.0.1.1-signed\",\"type\":\"extension\",\"scope\":1,\"description\":\"Solves those tricky authorization text filled images in web pages (CAPTCHAs) instead of you.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16880,\"updateDay\":16880},\"{a6fd85ed-e919-4a43-a5af-8da18bda539f}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"Selenium IDE\",\"version\":\"2.9.1\",\"type\":\"extension\",\"scope\":1,\"description\":\"Record, edit and play Selenium tests\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16882,\"updateDay\":16882},\"client@anonymox.net\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"anonymoX\",\"version\":\"2.5.2\",\"type\":\"extension\",\"scope\":1,\"description\":\"Easy anonymous web browsing and bypassing of web censorship. No proxys or other programs needed. With many functions to protect privacy.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16891,\"updateDay\":16891},\"admin@hide-my-ip.org\":{\"userDisabled\":true,\"appDisabled\":false,\"name\":\"Hide My IP\",\"version\":\"9.2.0\",\"type\":\"extension\",\"scope\":1,\"description\":\"Hide My IP is number one tool for hiding your IP and unblocking any web site!\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16897,\"updateDay\":16897},\"loop@mozilla.org\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"Firefox Hello Beta\",\"version\":\"1.1.14\",\"type\":\"extension\",\"scope\":1,\"description\":\"Web sharing for Firefox\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16864,\"updateDay\":16911},\"{3e9bb2a7-62ca-4efa-a4e6-f6f6168a652d}\":{\"userDisabled\":false,\"appDisabled\":false,\"name\":\"ShowIP\",\"version\":\"2.7.7.1-signed\",\"type\":\"extension\",\"scope\":1,\"description\":\"Show the IP address of the current page in the status bar. It also allows querying custom services by IP (right mouse button) and Hostname (left mouse button), like whois, netcraft. Additionally you can copy the IP address to the clipboard. This extension was formerly known as ipv6ident. License GPLv2 only.\",\"foreignInstall\":false,\"hasBinaryComponents\":false,\"installDay\":16911,\"updateDay\":16911}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #18 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #19 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #20 finished. Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #21 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #22 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":2,"days":16911,"value":"{\"nppdf32.dll:Adobe Acrobat:10.1.7.27:Adobe PDF Plug-In For Firefox and Netscape 10.1.7\":{\"mimeTypes\":[\"application/pdf\",\"application/vnd.adobe.pdfxml\",\"application/vnd.adobe.x-mars\",\"application/vnd.fdf\",\"application/vnd.adobe.xfdf\",\"application/vnd.adobe.xdp+xml\",\"application/vnd.adobe.xfd+xml\"],\"name\":\"Adobe Acrobat\",\"version\":\"10.1.7.27\",\"description\":\"Adobe PDF Plug-In For Firefox and Netscape 10.1.7\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npGoogleUpdate3.dll:Google Update:1.3.29.5:Google Update\":{\"mimeTypes\":[\"application/x-vnd.google.update3webcontrol.3\",\"application/x-vnd.google.oneclickctrl.9\"],\"name\":\"Google Update\",\"version\":\"1.3.29.5\",\"description\":\"Google Update\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPAUTHZ.DLL:Microsoft Office 2010:14.0.4730.1010:Office Authorization plug-in for NPAPI browsers\":{\"mimeTypes\":[\"application/x-msoffice14\"],\"name\":\"Microsoft Office 2010\",\"version\":\"14.0.4730.1010\",\"description\":\"Office Authorization plug-in for NPAPI browsers\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPSPWRAP.DLL:Microsoft Office 2010:14.0.4761.1000:The plug-in allows you to open and edit files using Microsoft Office applications\":{\"mimeTypes\":[\"application/x-sharepoint\"],\"name\":\"Microsoft Office 2010\",\"version\":\"14.0.4761.1000\",\"description\":\"The plug-in allows you to open and edit files using Microsoft Office applications\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npctrl.dll:Silverlight Plug-In:5.1.41212.0:5.1.41212.0\":{\"mimeTypes\":[\"application/x-silverlight\",\"application/x-silverlight-2\"],\"name\":\"Silverlight Plug-In\",\"version\":\"5.1.41212.0\",\"description\":\"5.1.41212.0\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npjp2.dll:Java(TM) Platform SE 7 U45:10.45.2.18:Next Generation Java Plug-in 10.45.2 for Mozilla browsers\":{\"mimeTypes\":[\"application/x-java-applet\",\"application/x-java-bean\",\"application/x-java-vm\",\"application/x-java-applet;version=1.1.1\",\"application/x-java-bean;version=1.1.1\",\"application/x-java-applet;version=1.1\",\"application/x-java-bean;version=1.1\",\"application/x-java-applet;version=1.2\",\"application/x-java-bean;version=1.2\",\"application/x-java-applet;version=1.1.3\",\"application/x-java-bean;version=1.1.3\",\"application/x-java-applet;version=1.1.2\",\"application/x-java-bean;version=1.1.2\",\"application/x-java-applet;version=1.3\",\"application/x-java-bean;version=1.3\",\"application/x-java-applet;version=1.2.2\",\"application/x-java-bean;version=1.2.2\",\"application/x-java-applet;version=1.2.1\",\"application/x-java-bean;version=1.2.1\",\"application/x-java-applet;version=1.3.1\",\"application/x-java-bean;version=1.3.1\",\"application/x-java-applet;version=1.4\",\"application/x-java-bean;version=1.4\",\"application/x-java-applet;version=1.4.1\",\"application/x-java-bean;version=1.4.1\",\"application/x-java-applet;version=1.4.2\",\"application/x-java-bean;version=1.4.2\",\"application/x-java-applet;version=1.5\",\"application/x-java-bean;version=1.5\",\"application/x-java-applet;version=1.6\",\"application/x-java-bean;version=1.6\",\"application/x-java-applet;version=1.7\",\"application/x-java-bean;version=1.7\",\"application/x-java-applet;jpi-version=1.7.0_45\",\"application/x-java-bean;jpi-version=1.7.0_45\",\"application/x-java-vm-npruntime\",\"application/x-java-applet;deploy=10.45.2\",\"application/x-java-applet;javafx=2.2.45\"],\"name\":\"Java(TM) Platform SE 7 U45\",\"version\":\"10.45.2.18\",\"description\":\"Next Generation Java Plug-in 10.45.2 for Mozilla browsers\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"npdeployJava1.dll:Java Deployment Toolkit 7.0.450.18:10.45.2.18:NPRuntime Script Plug-in Library for Java(TM) Deploy\":{\"mimeTypes\":[\"application/java-deployment-toolkit\"],\"name\":\"Java Deployment Toolkit 7.0.450.18\",\"version\":\"10.45.2.18\",\"description\":\"NPRuntime Script Plug-in Library for Java(TM) Deploy\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"np32dsw_1207148.dll:Shockwave for Director:12.0.7.148:Adobe Shockwave for Director Netscape plug-in, version 12.0.7.148\":{\"mimeTypes\":[\"application/x-director\"],\"name\":\"Shockwave for Director\",\"version\":\"12.0.7.148\",\"description\":\"Adobe Shockwave for Director Netscape plug-in, version 12.0.7.148\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":true},\"NPSWF32_11_9_900_170.dll:Shockwave Flash:11.9.900.170:Shockwave Flash 11.9 r900\":{\"mimeTypes\":[\"application/x-shockwave-flash\",\"application/futuresplash\"],\"name\":\"Shockwave Flash\",\"version\":\"11.9.900.170\",\"description\":\"Shockwave Flash 11.9 r900\",\"blocklisted\":false,\"disabled\":false,\"clicktoplay\":false}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #22 finished. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #23 INSERT OR REPLACE INTO last_text VALUES (:field_id, :days, :value) - {"field_id":3,"days":16911,"value":"{\"gmp-gmpopenh264\":{\"version\":\"1.5.3\",\"userDisabled\":false,\"applyBackgroundUpdates\":1},\"gmp-eme-adobe\":{\"version\":\"15\",\"userDisabled\":false,\"applyBackgroundUpdates\":1}}"} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #23 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Sqlite.Connection TRACE places.sqlite#0: Stmt #3 SELECT keyword, url, post_data FROM moz_keywords k JOIN moz_places h ON h.id = k.place_id Sqlite.Connection DEBUG places.sqlite#0: Stmt #3 finished. adbeaver.callback INFO DOMContentLoaded: https://www.google.co.il/ Sqlite.ConnectionCloner INFO Cloning database: C:\Users\User\AppData\Roaming\Mozilla\Firefox\Profiles\ppwcp417.default\places.sqlite (places.sqlite#2) Sqlite.ConnectionCloner INFO Connection cloned Sqlite.Connection INFO places.sqlite#2: Opened Sqlite.Connection TRACE places.sqlite#2: Stmt #0 PRAGMA cache_size = -6144 Sqlite.Connection DEBUG places.sqlite#2: Stmt #0 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #1 CREATE TEMP TABLE moz_openpages_temp ( url TEXT PRIMARY KEY, open_count INTEGER ) Sqlite.Connection DEBUG places.sqlite#2: Stmt #1 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #2 CREATE TEMPORARY TRIGGER moz_openpages_temp_afterupdate_trigger AFTER UPDATE OF open_count ON moz_openpages_temp FOR EACH ROW WHEN NEW.open_count = 0 BEGIN DELETE FROM moz_openpages_temp WHERE url = NEW.url; END Sqlite.Connection DEBUG places.sqlite#2: Stmt #2 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #3 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"https://www.google.co.il/"} Sqlite.Connection TRACE places.sqlite#2: Stmt #4 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"y"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #3 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #4 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #5 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"y","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #5 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #6 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"y","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #6 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #7 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"y","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #7 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #8 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"yn"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #8 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #9 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"yn","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #9 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #10 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yn","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #10 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #11 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yn","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #11 finished. Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #24 INSERT OR REPLACE INTO daily_counters VALUES ( :field_id, :days, COALESCE( (SELECT value FROM daily_counters WHERE field_id = :field_id AND day = :days ), 0 ) + :by) - {"field_id":66,"days":16911,"by":1} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #24 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Sqlite.Connection TRACE places.sqlite#2: Stmt #12 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"https://www.google.co.il/"} Sqlite.Connection TRACE places.sqlite#2: Stmt #13 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"https://www.google.co.il/search?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ"} Sqlite.Connection TRACE places.sqlite#1: Stmt #5 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"https://www.google.co.il/search?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #12 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #13 finished. Sqlite.Connection DEBUG places.sqlite#1: Stmt #5 finished. adbeaver.callback INFO DOMContentLoaded: https://www.google.co.il/search?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ Sqlite.Connection TRACE places.sqlite#2: Stmt #14 /* do not warn (bug no): cannot use an index to sort */ SELECT :query_type, h.url, NULL, f.url AS favicon_url, foreign_count > 0 AS bookmarked, NULL, NULL, NULL, NULL, NULL, NULL, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE (rev_host = :revHost OR rev_host = :revHost || "www.") AND h.frecency <> 0 AND fixup_url(h.url) BETWEEN :searchString AND :searchString || X'FFFF' AND h.typed = 1 ORDER BY h.frecency DESC, h.id DESC LIMIT 1 - {"query_type":2,"searchString":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ","revHost":"li.oc.elgoog."} Sqlite.Connection DEBUG places.sqlite#2: Stmt #14 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #15 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #15 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #16 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #16 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #17 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #17 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #18 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #18 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #19 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"google.co.il/y?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #19 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #20 /* do not warn (bug no): cannot use an index to sort */ SELECT :query_type, h.url, NULL, f.url AS favicon_url, foreign_count > 0 AS bookmarked, NULL, NULL, NULL, NULL, NULL, NULL, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE (rev_host = :revHost OR rev_host = :revHost || "www.") AND h.frecency <> 0 AND fixup_url(h.url) BETWEEN :searchString AND :searchString || X'FFFF' AND h.typed = 1 ORDER BY h.frecency DESC, h.id DESC LIMIT 1 - {"query_type":2,"searchString":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ","revHost":"li.oc.elgoog."} Sqlite.Connection DEBUG places.sqlite#2: Stmt #20 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #21 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #21 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #22 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #22 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #23 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #23 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #24 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #24 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #25 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"google.co.il/yn?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #25 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #26 /* do not warn (bug no): cannot use an index to sort */ SELECT :query_type, h.url, NULL, f.url AS favicon_url, foreign_count > 0 AS bookmarked, NULL, NULL, NULL, NULL, NULL, NULL, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE (rev_host = :revHost OR rev_host = :revHost || "www.") AND h.frecency <> 0 AND fixup_url(h.url) BETWEEN :searchString AND :searchString || X'FFFF' AND h.typed = 1 ORDER BY h.frecency DESC, h.id DESC LIMIT 1 - {"query_type":2,"searchString":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ","revHost":"li.oc.elgoog."} Sqlite.Connection DEBUG places.sqlite#2: Stmt #26 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #27 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #27 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #28 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #28 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #29 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #29 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #30 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #30 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #31 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"google.co.il/yne?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #31 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #32 /* do not warn (bug no): cannot use an index to sort */ SELECT :query_type, h.url, NULL, f.url AS favicon_url, foreign_count > 0 AS bookmarked, NULL, NULL, NULL, NULL, NULL, NULL, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON h.favicon_id = f.id WHERE (rev_host = :revHost OR rev_host = :revHost || "www.") AND h.frecency <> 0 AND fixup_url(h.url) BETWEEN :searchString AND :searchString || X'FFFF' AND h.typed = 1 ORDER BY h.frecency DESC, h.id DESC LIMIT 1 - {"query_type":2,"searchString":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ","revHost":"li.oc.elgoog."} Sqlite.Connection DEBUG places.sqlite#2: Stmt #32 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #33 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #33 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #34 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #34 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #35 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #35 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #36 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #36 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #37 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"google.co.il/ynet?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2uwxv8lgdsmuavoltogj","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #37 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #38 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"y"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #38 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #39 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"y","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #39 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #40 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"y","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #40 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #41 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"y","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #41 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #42 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"yn"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #42 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #43 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"yn","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #43 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #44 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yn","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #44 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #45 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yn","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #45 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #46 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"yne"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #46 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #47 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"yne","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #47 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #48 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yne","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #48 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #49 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"yne","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #49 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #50 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"yne","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #50 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #51 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"yne","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #51 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #52 /* do not warn (bug NA): not worth to index on (typed, frecency) */ SELECT :query_type, host || '/', IFNULL(prefix, '') || host || '/', ( SELECT f.url FROM moz_favicons f JOIN moz_places h ON h.favicon_id = f.id WHERE rev_host = get_unreversed_host(host || '.') || '.' OR rev_host = get_unreversed_host(host || '.') || '.www.' ) AS favicon_url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, frecency FROM moz_hosts WHERE host BETWEEN :searchString AND :searchString || X'FFFF' AND frecency <> 0 AND typed = 1 ORDER BY frecency DESC LIMIT 1 - {"query_type":1,"searchString":"ynet"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #52 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #53 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"ynet","query_type":0,"matchBehavior":1,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #53 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #54 SELECT :query_type, t.url, t.url, NULL, NULL, NULL, NULL, NULL, NULL, NULL, t.open_count, NULL FROM moz_openpages_temp t LEFT JOIN moz_places h ON h.url = t.url WHERE h.id IS NULL AND AUTOCOMPLETE_MATCH(:searchString, t.url, t.url, NULL, NULL, NULL, NULL, t.open_count, :matchBehavior, :searchBehavior) ORDER BY t.ROWID DESC LIMIT :maxResults - {"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"ynet","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #54 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #55 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":1,"searchBehavior":131,"searchString":"ynet","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #55 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #56 /* do not warn (bug 487789) */ SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM ( SELECT ROUND(MAX(use_count) * (1 + (input = :search_string)), 1) AS rank, place_id FROM moz_inputhistory WHERE input BETWEEN :search_string AND :search_string || X'FFFF' GROUP BY place_id ) AS i JOIN moz_places h ON h.id = i.place_id LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE AUTOCOMPLETE_MATCH(NULL, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY rank DESC, h.frecency DESC - {"parent":4,"search_string":"ynet","query_type":0,"matchBehavior":0,"searchBehavior":131} Sqlite.Connection DEBUG places.sqlite#2: Stmt #56 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #57 SELECT :query_type, h.url, h.title, f.url, EXISTS(SELECT 1 FROM moz_bookmarks WHERE fk = h.id) AS bookmarked, ( SELECT title FROM moz_bookmarks WHERE fk = h.id AND title NOTNULL ORDER BY lastModified DESC LIMIT 1 ) AS btitle, ( SELECT GROUP_CONCAT(t.title, ', ') FROM moz_bookmarks b JOIN moz_bookmarks t ON t.id = +b.parent AND t.parent = :parent WHERE b.fk = h.id ) AS tags, h.visit_count, h.typed, h.id, t.open_count, h.frecency FROM moz_places h LEFT JOIN moz_favicons f ON f.id = h.favicon_id LEFT JOIN moz_openpages_temp t ON t.url = h.url WHERE h.frecency <> 0 AND AUTOCOMPLETE_MATCH(:searchString, h.url, IFNULL(btitle, h.title), tags, h.visit_count, h.typed, bookmarked, t.open_count, :matchBehavior, :searchBehavior) ORDER BY h.frecency DESC, h.id DESC LIMIT :maxResults - {"parent":4,"query_type":0,"matchBehavior":0,"searchBehavior":131,"searchString":"ynet","maxResults":12} Sqlite.Connection DEBUG places.sqlite#2: Stmt #57 finished. Services.Metrics.MetricsStorage TRACE Enqueueing operation. Services.Metrics.MetricsStorage TRACE Performing queued operation. Sqlite.Connection TRACE healthreport.sqlite#0: Stmt #25 INSERT OR REPLACE INTO daily_counters VALUES ( :field_id, :days, COALESCE( (SELECT value FROM daily_counters WHERE field_id = :field_id AND day = :days ), 0 ) + :by) - {"field_id":66,"days":16911,"by":1} Sqlite.Connection DEBUG healthreport.sqlite#0: Stmt #25 finished. Services.Metrics.MetricsStorage TRACE Queued operation completed. Sqlite.Connection TRACE places.sqlite#2: Stmt #58 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"https://www.google.co.il/search?q=yn&ie=utf-8&oe=utf-8&gws_rd=cr&ei=2UwXV8LgDsmuavOLtogJ"} Sqlite.Connection TRACE places.sqlite#2: Stmt #59 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"https://www.google.co.il/search?q=ynet&ie=utf-8&oe=utf-8&gws_rd=cr&ei=4EwXV7KeDoKZaY7xqOAG"} Sqlite.Connection TRACE places.sqlite#1: Stmt #6 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"https://www.google.co.il/search?q=ynet&ie=utf-8&oe=utf-8&gws_rd=cr&ei=4EwXV7KeDoKZaY7xqOAG"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #58 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #59 finished. Sqlite.Connection DEBUG places.sqlite#1: Stmt #6 finished. adbeaver.callback INFO DOMContentLoaded: https://www.google.co.il/search?q=ynet&ie=utf-8&oe=utf-8&gws_rd=cr&ei=4EwXV7KeDoKZaY7xqOAG Sqlite.Connection TRACE places.sqlite#2: Stmt #60 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"about:addons"} Sqlite.Connection TRACE places.sqlite#1: Stmt #7 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"about:addons"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #60 finished. Sqlite.Connection DEBUG places.sqlite#1: Stmt #7 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #61 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"about:addons"} Sqlite.Connection TRACE places.sqlite#2: Stmt #62 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"about:addons"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #61 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #62 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #63 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"about:addons"} Sqlite.Connection TRACE places.sqlite#2: Stmt #64 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"about:addons"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #63 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #64 finished. Services.DataReporting.Policy DEBUG Data submission is disabled. Doing nothing. Sqlite.Connection TRACE places.sqlite#2: Stmt #65 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"about:addons"} Sqlite.Connection TRACE places.sqlite#2: Stmt #66 INSERT OR REPLACE INTO moz_openpages_temp (url, open_count) VALUES ( :url, IFNULL( (SELECT open_count + 1 FROM moz_openpages_temp WHERE url = :url), 1 ) ) - {"url":"about:addons"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #65 finished. Sqlite.Connection DEBUG places.sqlite#2: Stmt #66 finished. Sqlite.Connection TRACE places.sqlite#2: Stmt #67 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"about:addons"} Sqlite.Connection TRACE places.sqlite#1: Stmt #8 SELECT b.id FROM moz_bookmarks b JOIN moz_places h on h.id = b.fk WHERE h.url = :url - {"url":"https://www.google.co.il/search?q=ynet&ie=utf-8&oe=utf-8&gws_rd=cr&ei=4EwXV7KeDoKZaY7xqOAG"} Sqlite.Connection DEBUG places.sqlite#2: Stmt #67 finished. Sqlite.Connection DEBUG places.sqlite#1: Stmt #8 finished. Sync.Status INFO Resetting Status. Sync.Status DEBUG Status.service: undefined => success.status_ok Sqlite.Connection TRACE places.sqlite#2: Stmt #68 UPDATE moz_openpages_temp SET open_count = open_count - 1 WHERE url = :url - {"url":"https://www.google.co.il/search?q=ynet&ie=utf-8&oe=utf-8&gws_rd=cr&ei=4EwXV7KeDoKZaY7xqOAG"} Services.HealthReport.HealthReporter INFO Request to shut down. Services.HealthReport.HealthReporter WARN Initiating main shutdown procedure. Services.HealthReport.HealthReporter INFO Shutting down provider manager. Services.HealthReport.HealthReporter INFO Shutting down provider: org.mozilla.addons